from flask_appbuilder import Model
from sqlalchemy import Column, ForeignKey, Integer, String
from sqlalchemy.orm import relationship

from myapp.app import security_manager
from myapp.models.helpers import AuditMixinNullable


class UserAttribute(Model, AuditMixinNullable):
    """
    Custom attributes attached to the user.

    Extending the user attribute is tricky due to its dependency on the
    authentication typew an circular dependencies in Myapp. Instead, we use
    a custom model for adding attributes.

    """

    __tablename__ = 'user_attribute'
    id = Column(Integer, primary_key=True)  # pylint: disable=invalid-name
    user_id = Column(Integer, ForeignKey('ab_user.id'))
    user = relationship(
        security_manager.user_model, backref='extra_attributes', foreign_keys=[user_id]
    )
    storage_size = Column(Integer, nullable=False, default=0, comment='存储限额')
    pipeline_is_initialized = Column(Integer, nullable=False, default=0, server_default='0', comment='pipeline是否初始化')
    service_is_initialized = Column(Integer, nullable=False, default=0, server_default='0', comment='service是否初始化')
    region = Column(String(100), nullable=False, default='default', server_default='default', comment='地区')
